from re import S
import os,sys
from dotenv import load_dotenv

load_dotenv()

MYSQL_DATABASE=os.getenv('MYSQL_DATABASE')
MYSQL_USER=os.getenv('MYSQL_USER')
MYSQL_PASSWORD=os.getenv('MYSQL_PASSWORD')
MYSQL_HOST=os.getenv('MYSQL_HOST')
MYSQL_PORT=os.getenv('MYSQL_PORT')
MYSQL_CHARSET=os.getenv('MYSQL_CHARSET','utf8mb4')

SNOWFLAKE_DATACENTER_ID=os.getenv('SNOWFLAKE_DATACENTER_ID',0)
SNOWFLAKE_WORKER_ID=os.getenv('SNOWFLAKE_WORKER_ID',0)


DB_URL=f"mysql+asyncmy://{MYSQL_USER}:{MYSQL_PASSWORD}@{MYSQL_HOST}:{MYSQL_PORT}/{MYSQL_DATABASE}?charset={MYSQL_CHARSET}"
